SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328083 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328083 [ RunTime:0.004222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595503,647372,569770,160050,575238,788205,917966,880845,1031945,290348,646880,108178,380422,874556,1040557,400501,784183,1026994,357878,623467,829988,711738,887251,1020277,1007064,977136,113017,167414,815952,625226,733017,153526,628520,141146,700317,173729,791719,144829,988055,245928,616886,99106,711688,241851,518044,933473,209348,964287,445110,722335,1035150,389868,619488,745060,230173,229882,862890,914547,884376,874044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]