SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241516 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241516 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603180,510370,279805,105225,101496,135112,371476,672860,43983,942370,244889,230685,571120,196141,1005196,653263,46237,84711,708300,391887,508254,656387,845980,553596,888329,632664,870497,292939,742969,956260,793511,1001628,135446,93007,1011895,645232,689314,1039712,593975,931290,556393,920272,612641,543946,737918,200354,222319,886604,171721,334043,40927,890506,336807,420223,175706,280228,79698,756202,344438,609981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]