SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585210 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585210 [ RunTime:0.003980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912475,117863,249167,405808,454451,402200,396821,454883,111556,291987,854344,224403,724026,332597,543845,243047,53379,492851,43737,415089,792637,811925,303190,125813,892165,410036,758321,310557,790047,227391,45781,619362,384117,501405,898113,26985,479511,799915,191361,1026904,54041,59340,161248,368992,578486,372320,987424,102913,700332,265057,590328,841874,86328,229003,338270,740943,736159,1016718,623733,509148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]