SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545615 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545615 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496401,243221,128415,378491,387314,104504,395516,435268,745791,206319,928791,529171,723735,972839,1034594,151205,823183,336179,743259,753296,816090,807693,404760,272019,52996,662195,461756,1039938,42474,737903,225189,820776,1044234,355054,290999,362479,233271,578767,448951,77535,113802,111458,297116,168655,272890,480028,915298,508171,858197,518729,324714,285593,108737,492935,748609,250116,1045099,772835,51871,494262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]