SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459527 LIMIT 1 [ RunTime:0.002139s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459527 [ RunTime:0.006087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797928,296835,415797,49371,899457,664081,444009,810332,938268,895398,432575,315839,413627,39754,995329,674018,139066,356475,1032391,365219,929553,177545,518171,487234,860185,682060,558507,896795,497025,1014663,356470,607995,311015,869093,743047,310442,742468,983892,534813,717447,48895,452181,925702,644644,973066,65179,839391,144855,454137,88325,465147,26959,376964,456925,667156,295187,893902,544409,910855,1023053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001660s ]