SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511084 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511084 [ RunTime:0.003328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729431,880430,788980,298922,485965,421633,151842,561416,983167,689382,202253,914004,542008,1017567,506883,707936,537478,335021,704985,700050,467907,553471,826394,282645,952003,265943,898759,441794,162225,461490,622279,610254,461763,432422,797254,809248,111791,556541,449105,38049,280252,167769,242881,133683,185509,898777,509759,561680,1028856,664184,872132,618363,83426,937220,592449,277777,497469,951652,978253,549715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001956s ]