SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517203 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517203 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681660,94769,696129,288612,1020962,558355,144392,505685,302288,835858,197135,350540,930615,689414,966429,570397,482773,888616,560428,352641,687516,18227,813157,248345,642079,60386,409478,267987,228587,390724,454119,920422,562602,366451,533405,787161,206654,1003796,866680,401035,784075,637210,919720,293036,79847,636711,723216,482905,507199,61839,738305,761499,659172,737051,308186,130184,955215,537092,256543,533905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]