SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010621 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010621 [ RunTime:0.003026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556844,232190,966056,1018322,598272,712740,880859,501862,351103,162861,964874,895497,400841,776957,728660,584256,899791,209974,1007000,179997,1019976,387377,617583,651363,87795,109746,460947,919612,695101,118972,97049,1001122,298972,1021843,442103,146687,299905,1013527,623361,26523,420493,458067,398776,924615,157552,62166,810097,387581,905917,131888,757134,518854,424294,628645,766364,65216,949079,602319,632273,211414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]