SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347915 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347915 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14703,518291,541573,101387,230739,772620,671215,314895,3206,868041,478033,156305,818084,424176,840912,192028,747463,57323,893403,158123,655715,861241,823731,280050,871989,666770,272887,717071,865723,377867,747195,677638,373880,377564,1045649,104544,233803,870461,19869,1028706,327598,950098,1023515,665453,911190,136563,1011794,208757,236421,952806,1026777,967629,205046,478424,346686,397149,508058,354797,914181,506853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]