SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531613 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531613 [ RunTime:0.003456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497137,380079,876751,970471,232017,90030,353659,478351,444682,211624,587271,686795,5560,503877,992286,268324,1040242,231565,66875,770285,424071,262555,352610,649843,720956,974422,917985,731634,498734,607644,699145,907377,20392,670718,117792,241697,646746,573772,11251,538287,560141,561793,584227,79093,323555,716472,96584,87255,933190,796621,1027121,113444,1032422,684597,735910,340693,270223,419427,612637,466298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]