SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404157 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404157 [ RunTime:0.001430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809558,225640,279321,266087,774270,643018,82305,649301,30910,376662,150243,1020351,427557,940815,468785,661456,106030,613303,374123,139579,672497,244259,263714,939309,517677,657951,1037401,14348,80685,400665,989161,739263,285618,177771,1026408,220816,536226,1034326,370133,838711,1031112,896657,1004455,443788,1035150,220347,776683,221211,870041,973689,822114,454718,380197,360485,920526,328720,436048,141672,307243,319869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]