SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548245 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548245 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006671,273651,577699,126929,474011,965377,778448,875774,630224,616327,314834,286122,895284,154900,585551,749388,263350,361254,438932,201124,373626,10438,95880,852574,593178,934115,937818,69432,99422,167996,562536,639949,734251,588009,1012222,223060,490506,233359,178773,105010,574859,266501,857974,254315,354045,588238,621411,1036187,612229,142564,223198,180392,1042310,250168,128603,218856,203342,281191,575815,762422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]