SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295010 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295010 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250636,532063,364845,743913,364196,141235,191362,714318,696286,32848,280307,159695,725232,791869,229231,405087,421351,427643,740686,367742,428315,519846,534753,389580,928951,969021,250009,444752,664503,255487,866520,389318,644978,805589,592148,462455,881684,274605,407566,109678,663869,897725,352603,899500,619228,734206,130224,336787,599083,316035,574663,275831,434199,40260,749444,130548,1013964,730725,1041620,372032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]