SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424223 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424223 [ RunTime:0.002526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31422,646578,809488,432019,439953,1043810,812007,28424,820129,619551,238056,490928,76810,102999,919610,457901,142062,786596,661510,220471,43302,1048290,158579,451616,417797,27210,792811,904386,589442,719505,666074,504876,828784,197281,634859,903956,144084,6539,474013,819747,756049,311770,117944,148717,190718,788816,661640,28907,696682,511430,678943,508751,410058,420815,160581,4220,933641,914603,255636,995109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]