SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292222 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292222 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299489,903828,347851,257516,373927,1010638,186134,255584,356022,342481,910575,830397,545000,812837,859591,481465,1032330,53612,926103,119357,991276,390355,56680,930650,300857,368443,604802,75919,1027300,867602,207647,413982,742203,1046310,846914,951730,809304,956293,198972,953835,182285,431287,875710,125188,737153,10965,978717,1022119,1019942,39130,831532,29495,745990,213778,8088,405052,634303,944595,969879,461776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]