SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501074 LIMIT 1 [ RunTime:0.001923s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501074 [ RunTime:0.003317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743467,936014,1022370,528696,861354,951362,253014,307742,231908,624433,315950,1042076,757718,498230,273537,1038671,250285,147933,378415,644094,511196,799525,622600,229539,974280,66619,715351,187569,503987,820071,254310,552544,672577,347198,171226,1038040,454492,712614,652658,549494,945387,860922,247788,405424,220558,304370,848847,183105,612560,766135,289754,149675,756424,376141,442701,607282,903216,859387,71270,614614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]