SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814215 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814215 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108797,278000,884235,547178,111024,874768,449168,297510,415917,333359,283432,169897,204154,1029301,1033326,741397,814812,294597,404130,38542,269241,761883,270388,940360,785642,33004,575182,169518,95739,69579,350098,112430,378417,58019,1021879,146255,529166,500533,35424,949064,533865,837878,41280,684514,815881,425942,560007,42007,171890,558498,906167,394340,372590,758735,139445,247719,274721,788534,883005,305066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]