SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36100 LIMIT 1 [ RunTime:0.003967s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36100 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033160,774754,68747,203600,38567,90526,443577,685695,174366,164793,512578,417357,104545,988852,116999,288406,254503,196541,158455,766515,329687,629989,580294,58411,235989,193797,603538,621062,365179,582354,1044115,282636,254973,631443,227267,34065,974951,758241,976778,660270,515929,588890,981861,794384,347288,452033,61485,541937,603228,329838,510478,292369,388471,348304,125620,99317,433733,666989,409349,556345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]