SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39208 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39208 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261677,823514,747988,382882,580217,478197,446289,565980,8224,12083,890225,146365,644868,565631,138791,789273,1002661,156213,227398,930997,801961,239256,22658,317349,643690,448570,815928,1030942,785268,862980,822287,569223,90268,794625,178863,392768,887739,218259,895831,145025,394609,537037,378214,906499,418587,710921,993114,957797,300017,728277,811615,438116,778773,400529,386594,696545,638949,536954,829022,334952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]