SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 939272 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 939272 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046058,17166,101641,775597,403602,735185,676324,647296,735138,655551,896267,841048,53421,26170,931510,838347,531235,32549,600338,569749,663438,12517,107237,538133,509052,785086,124992,875749,264664,621227,482063,552625,416849,566358,737064,800611,776987,941917,905631,339706,1034804,697730,862116,910120,1007472,579668,155715,386142,918098,327170,117276,841204,658971,333270,151307,115891,775015,880138,461131,537579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 939272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 939272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]