SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285197 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285197 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264891,497325,773344,489182,412142,89976,294210,745210,207643,768317,793718,107612,341053,812655,301989,563404,994428,661923,565394,185182,630590,984656,203309,271556,317417,290901,950943,773051,223477,897599,248525,748533,99688,568781,364202,238081,423299,434064,379815,1008453,1006930,1021666,236686,101503,530063,891356,573067,702467,698313,274511,490416,108922,448337,648342,756570,937833,410877,866120,718050,77319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]