SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492956 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492956 [ RunTime:0.002918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594562,266981,234618,1030746,827036,701646,365586,201310,93980,49882,411118,653863,216264,928813,248586,553283,631618,150290,400933,66853,435431,451348,507332,498114,313876,1024853,757928,150416,113962,1039162,673890,75922,480025,323064,303598,822523,821375,516772,175263,718060,733203,327499,354728,550425,525994,635163,549335,129324,971886,772443,791181,330386,1041352,789552,920745,349008,696423,163888,1048922,340496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001420s ]