SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545006 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545006 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682161,553883,323165,319447,710108,678458,737058,376309,518395,311512,1038692,850365,35517,633877,119972,938003,654519,277665,582518,1027025,417120,583900,830089,658403,122858,185261,249896,231446,901365,95306,484650,772755,372099,252579,158386,71805,86651,576338,739706,687490,201800,612792,161178,102579,540444,389309,505532,326520,572298,516757,3558,162732,907747,976499,227989,539370,1034821,726434,634861,242745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]