SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455676 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455676 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039331,15502,27894,966470,315122,845379,173280,186308,333615,20162,1022848,47462,980618,474842,633177,54229,424347,339468,332049,868286,465381,659211,858528,810183,436199,852218,563072,190224,426109,935534,304007,938699,975647,83688,579567,316265,788992,141697,428514,280105,449552,806565,274639,987138,961068,691517,972518,386410,352944,665520,769470,413430,726930,831854,103812,103339,841640,351932,208864,880568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]