SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001667s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009477 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009477 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9589,171394,860086,923552,915880,273247,982526,391178,422220,212994,147203,65129,885642,403586,258906,596612,917723,533497,56087,520194,920886,310793,736108,102786,678869,787040,17942,994499,905947,901750,343005,622077,723552,76972,590956,1038823,102890,398008,420693,116145,269581,242757,1005617,105926,1002821,23723,326187,786537,22230,26680,504417,333131,601500,248387,480856,49525,297120,320710,822624,842447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]