SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507181 LIMIT 1 [ RunTime:0.001994s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507181 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297306,235650,883070,115977,442547,838471,202191,411890,663977,262771,416879,810566,798377,687912,627267,972861,865968,212830,813003,344975,832735,841668,6117,178626,96313,430359,538593,5244,551065,854915,392143,972849,20934,503356,762115,345457,716489,746339,364531,211347,149065,450478,484240,299090,610839,308288,993447,657082,145705,174431,470727,517043,412524,152601,827407,334749,243886,64695,670586,244381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]