SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402118 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402118 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438688,891492,339212,397581,781822,100740,138894,185534,501341,236337,922225,624797,299182,172582,486204,994140,345013,616494,171250,259287,135893,393054,825342,895624,798240,719578,704426,9901,855472,806757,710063,241684,957321,932270,168161,508167,946988,143135,385606,1029528,620427,539182,285648,377126,210963,902644,70669,861776,494087,866282,738502,773184,833407,485047,1045601,251859,264333,249699,603234,574663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]