SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002633s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023585 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023585 [ RunTime:0.003114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171161,674507,926545,1009146,790343,300848,916023,526378,418501,675761,403514,242883,366500,554251,968753,313557,558335,701527,1038280,440336,900105,495780,58616,619507,332995,40703,228015,1047933,482100,481715,75981,272348,386204,666672,216442,696886,135737,713897,309024,486205,877450,260587,138963,754682,257401,360839,872738,89601,1045632,666728,97116,679974,528949,776310,642713,1042362,267587,892607,941538,729506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000943s ]