SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53705 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53705 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535358,257107,475864,703436,399689,111444,583363,189780,944831,764742,359118,195406,704171,5997,758594,769014,674672,336583,26217,641720,758351,352149,501679,172229,467425,886473,358628,280319,979142,1002381,103011,295033,851448,40929,724469,885289,683255,570903,984870,819845,281539,510253,1658,561213,901514,526604,578289,690985,583882,851207,632381,292868,989770,432506,678746,352386,638032,567399,119278,384097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]