SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002685s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493648 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493648 [ RunTime:0.003991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682076,134605,169262,688833,476789,994610,142588,470560,698399,739869,532950,739489,468539,110177,525059,884785,125598,370187,173202,521782,85105,417713,100295,272090,38004,689585,1019486,422248,485009,406162,984742,982477,979743,647489,268483,294512,834039,465894,988402,178967,778348,980018,818686,135894,784500,329184,1043927,316555,711265,93901,210595,131889,977623,247060,591282,20569,209211,541979,372462,253685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001180s ]