SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399208 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399208 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752633,453011,365264,486662,127755,396416,138951,906378,557540,467423,990421,553982,1020898,1048832,23657,938706,768215,128256,456279,975204,169136,622581,319977,310306,601042,484367,391584,789790,45050,855919,918754,732304,201820,95093,463790,959196,472884,564191,306068,378848,88099,343076,969622,810761,964289,323870,809855,52639,57409,656388,909504,140848,471712,696600,90734,1016167,247607,881581,846583,611464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002317s ]