SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204601 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204601 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419818,802931,600457,897538,395340,279150,269651,933380,298576,118513,458134,156276,837937,936358,766256,957867,113424,931445,847091,214418,661,138579,1039745,729039,463516,242776,76148,598958,301597,698693,912276,1042026,1006421,248849,135958,411886,877006,71751,326084,498569,703526,919519,974903,342099,934025,961226,941628,90048,229871,900616,44963,389197,954341,582422,19295,12397,740382,100521,165007,542788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002030s ]