SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38388 LIMIT 1 [ RunTime:0.002322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38388 [ RunTime:0.004100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153001,1003026,868645,522881,1012281,130868,665964,59280,674164,226965,181096,695931,835996,898383,531621,329825,217634,674572,868869,407395,650800,86206,59457,729795,348007,809812,408351,974247,102339,271599,51301,125789,262136,53937,156680,12011,181870,738144,273661,158051,723785,992533,517239,318949,432902,606172,485066,168320,548914,699707,557119,919048,927770,796470,31095,586518,175407,705582,506715,404168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001074s ]