SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471508 LIMIT 1 [ RunTime:0.000807s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471508 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872779,61086,148316,110433,800879,875503,192243,620939,969172,34958,574208,427849,443149,49593,314331,443066,695033,282802,572502,356893,592648,301746,1032014,763124,845023,601885,672287,781370,469586,353935,314030,1011374,713330,910076,743793,861373,510536,543540,596174,84156,184040,1023148,177325,1015522,497578,644318,716770,216377,866245,13927,297214,607915,1020234,867489,608353,653026,153659,138967,195120,470898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]