SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 864596 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 864596 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703537,382851,188357,432112,360587,847409,460112,1002605,963094,1040943,884878,982582,601992,1014673,662344,184588,644851,197262,302158,782416,99124,327141,780795,597800,969413,652344,941000,696391,387096,965410,129077,757392,871563,680675,994372,656750,745980,744989,299898,863507,736947,838562,817769,215670,237692,765,106045,378494,735664,685880,948658,542179,702681,24856,974284,659076,388603,320920,573070,938093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 864596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 864596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]