SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504697 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504697 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170602,125570,893181,618316,548904,277555,422288,697533,961498,1001117,1018044,317595,930545,138382,176820,987827,221760,466414,839963,149186,814150,447224,332984,405679,47,916156,510682,937127,359085,133552,874903,630959,713165,15942,1029806,877787,419891,101102,626523,831516,481105,910350,392754,314072,520809,938112,731349,373357,543909,270915,200678,250061,553596,773180,942455,238274,742578,178879,779169,555842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]