SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543910 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543910 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99478,540916,189538,448475,1008442,793057,156705,443773,525677,746648,546313,189158,903459,725902,427957,924798,765500,479237,220176,711124,887661,271799,402259,482674,439415,290424,30312,452933,522074,910145,491042,792537,519354,145820,577233,473331,1047070,467530,359398,1022730,405336,730364,416076,857152,14162,544363,726076,713362,129591,405639,19262,193761,111367,443092,12635,424082,437044,151130,580116,960236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]