SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459644 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459644 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418920,505375,572291,76197,709900,43563,4343,1013503,859802,123621,276959,803723,361540,49658,115303,344537,211071,181750,993456,249285,1047203,388138,243177,971946,281693,840852,909267,567809,36350,964122,210086,288854,259414,681534,864646,108017,235418,562117,700062,890508,660268,778819,210678,907926,689048,723072,162946,713857,89488,594753,238162,843003,360766,265093,240119,298192,469012,729368,888551,763357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]