SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41801 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41801 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101046,747833,117551,1040563,978306,986070,918084,55602,798641,441417,184549,427422,712379,557542,806492,929821,839883,712483,843300,823593,651185,892244,366567,979912,482878,761036,790756,588973,456125,553917,19301,523297,219579,475506,775363,1042909,482483,311806,1016274,1031919,242982,245534,127410,592913,163894,686674,488623,725795,752541,866187,216999,876008,546444,105116,446994,677495,650950,58375,94924,317670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000777s ]