SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 741004 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 741004 [ RunTime:0.004409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65785,167213,561156,843877,90445,689929,30244,381552,427103,849484,966732,961222,456117,641124,440651,803585,406811,108367,457067,2937,136875,867846,104001,58433,781806,110493,161430,1013989,1041574,51312,409488,556015,105067,277481,222840,737987,951280,860934,22006,591995,821661,135617,1033273,233653,217515,915821,356989,434612,523938,250448,567912,172631,507741,845335,960544,657842,378920,496664,1023199,847652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 741004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 741004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]