SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501123 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501123 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975878,458984,1004455,744975,835538,629223,117522,247623,713434,916059,699061,773723,338090,130944,154421,896720,499706,363860,512630,542673,1007474,444603,313990,16109,107398,368874,442647,197638,778520,929697,444377,485351,309582,507263,721834,528727,478437,600295,590009,422368,68798,638126,456909,769593,737251,437475,462995,680552,698556,737459,53961,505742,585322,37543,606968,175751,584834,84510,210653,1017333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501123 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501123 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]