SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510527 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510527 [ RunTime:0.002366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38433,306648,392201,181071,11771,429372,135039,511684,224929,283049,693317,682705,588729,916566,805508,869765,532306,383531,143053,857285,750072,574491,1042171,44029,776998,47490,538590,973276,111459,812960,1036450,384113,39684,887922,271713,951728,65059,263770,548466,596320,937396,350754,574947,293530,1019133,313136,843782,825496,907513,319657,489463,538691,987550,78611,903330,363589,853972,802986,995971,687621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000819s ]