SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419784 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419784 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750536,34875,875873,429979,911409,881524,579554,13291,908455,791095,361260,66534,671486,376483,915932,311580,406070,388958,92323,198740,153791,366432,809813,263155,785336,320055,953905,772915,534126,122054,956894,919737,916384,86826,466146,118980,231949,448127,701331,438809,520431,680333,893262,228199,478292,338938,441992,654058,316766,1029875,852641,417792,589007,817730,716080,379751,577081,377998,101069,819096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419784 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419784 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]