SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484009 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484009 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029252,732003,303337,326625,81500,942560,329570,351593,472127,517877,138198,896364,361921,701419,801204,41450,651282,352450,9154,851437,356119,91237,866557,830188,178266,1033253,836948,496781,140192,493774,347440,217154,764730,946746,577269,9612,489548,429263,718856,531162,519519,335276,260908,774602,906898,963895,500882,84045,733254,208316,613771,204611,530202,721687,606671,910812,303203,657758,206152,605329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]