SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320438 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320438 [ RunTime:0.004314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337193,412212,587430,875876,485400,280393,848950,984842,601094,971671,319247,146167,933734,1007113,1001887,833334,902949,587418,864502,578348,725094,600106,502020,300024,583874,279239,43592,1041595,9627,310677,880398,1006227,933071,904828,160631,656346,325634,372004,521132,753661,421169,53547,971420,413294,447951,916754,158388,97765,543067,265563,533920,533100,656056,429683,219862,704065,240134,541072,760443,280914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]