SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432311 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432311 [ RunTime:0.005399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431921,302032,159609,85275,842421,1033003,485349,929923,160028,769493,262765,99128,254318,107200,400405,577347,19422,937425,921134,450500,441909,238564,263485,312010,378712,471140,731263,10730,250020,926245,1036889,325712,92378,568235,1042126,454799,93854,29094,360257,559358,896921,452959,314171,143274,678334,631876,571976,148403,896350,766138,616918,882380,531613,319223,659689,856771,1028068,784634,204180,185096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]