SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545082 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545082 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017406,774635,707424,384926,329174,734634,612571,784570,907794,859089,641354,507165,390009,337746,853454,977597,1012073,870002,705289,558070,558080,7152,112648,199281,889652,899638,903158,426797,685071,587500,205761,588312,180671,661966,204719,785288,645408,577102,206044,151092,912882,894564,701505,930913,967535,677880,322281,515325,437578,725540,184475,79298,528002,938787,255159,329459,697277,78171,318827,43996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]