SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154918 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154918 [ RunTime:0.002285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706601,941444,121679,969322,9184,984219,700088,289870,781390,255518,199589,720616,360087,971728,480740,325050,451590,1007602,981129,185440,491203,513672,312623,129080,1014899,654039,261380,239876,86312,113123,754893,461719,37557,746002,806823,149206,122328,963723,1041073,413968,303111,717768,776255,453021,394845,530852,440456,730710,296704,893108,66284,57951,173558,460814,803640,52622,437292,394310,856376,272974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]