SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10004 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10004 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940500,328243,702622,116340,317083,149787,642739,880975,398902,785575,718970,670263,11120,14749,279086,366599,280698,357021,831696,844197,776151,862963,2838,753107,600313,1015783,799153,61040,681468,829683,500198,895741,750200,1017697,71923,116263,1018232,918818,45886,1025290,240036,107755,984414,653280,856428,940644,736434,749070,593846,830656,702409,938718,69633,764467,171613,913733,622791,59059,977569,907641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]