SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035230 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035230 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223782,334681,634660,102347,675923,810467,487191,627360,948016,31584,104894,524682,286674,521979,158421,740971,852588,74310,706903,886439,682981,1023133,926657,265287,1044892,554048,184927,1008277,746178,262051,523569,331272,998997,508297,901439,88807,434262,479396,418383,48588,458062,696546,853110,369211,929444,643664,724835,904225,171301,774718,993391,437342,1027707,720544,694047,598762,205355,462940,543159,927865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]