SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401065 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401065 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579243,142471,327588,302535,329620,835327,569028,1027835,592584,815563,616146,676386,769181,345139,1030938,317789,428662,357148,892777,324548,751717,776305,559506,158387,48521,275560,484487,50975,764454,1012465,643135,148660,616626,191736,554787,395493,461546,93516,946109,1034916,1010975,577100,590663,18354,260713,727560,610349,718969,299245,779614,257998,332885,362937,607699,605172,440048,687361,825449,797884,310737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]