SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001283 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001283 [ RunTime:0.003359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172576,546389,653283,341693,437251,255054,895545,301565,928878,375972,141935,799083,317088,81238,416559,222999,195894,81966,61178,1017863,138054,608998,408059,11083,43317,562508,321342,783333,200365,670554,251028,583746,378864,374744,398638,724348,78814,200283,47692,852408,1009106,858013,25211,689495,231417,842030,257395,171799,391351,911266,363101,584041,889503,950295,507302,813659,443117,670607,299521,816459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]