SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002988s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201718 LIMIT 1 [ RunTime:0.003553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201718 [ RunTime:0.003596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177219,820400,996235,1030690,771994,525018,989168,925330,529397,938781,610969,602923,1015805,553996,335531,545845,320677,865901,814659,808726,800840,220786,885004,646400,696472,324948,690053,38774,443266,420942,662860,261118,136217,1035962,646841,707284,898537,303858,67016,429116,285761,673644,978128,448584,291927,267150,577578,806442,648876,442755,468087,1045486,458243,709424,311510,443729,866475,291570,244480,552292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]