SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575033 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575033 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495046,156206,499985,118802,44608,346753,707927,297962,821151,998381,908077,313351,1001229,648387,131746,689804,965495,384331,220997,111088,38595,743915,22458,346215,791463,334643,562839,354040,487726,816506,670240,925709,23064,346865,217295,125864,816378,265948,980593,602388,527880,76395,598636,133129,457368,481601,1027960,687458,455056,134980,637694,41856,175352,8482,466733,348609,527808,1027184,886574,642653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]