SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505083 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505083 [ RunTime:0.002396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120523,129745,230563,737203,776870,1035448,815511,856128,760582,426964,110014,81323,856893,789937,976182,340493,56233,877698,740673,415929,574949,674979,263412,503155,91618,886935,539338,213508,851966,489141,1031973,266480,966022,690559,505274,775,717657,875308,565930,892091,763236,317370,330482,198194,859425,697264,153469,759265,801645,874049,1000791,494221,497487,1029669,466343,874658,665889,635293,645331,907655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]