SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001807s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403398 LIMIT 1 [ RunTime:0.000848s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403398 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220673,12974,313416,975091,554344,1030223,730367,340373,678653,708430,864182,467346,61864,324643,504865,497546,319824,1042746,834204,726976,959745,669085,603713,647616,144381,175709,68779,179552,798469,646256,788689,137257,837370,898722,907865,998682,421242,191177,767946,966825,16485,1006669,667708,519273,489624,1042845,1010519,951206,59988,864019,374008,321222,791919,996040,1044749,489184,758707,609748,891765,794465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]