SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5222 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5222 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587035,173684,415004,193272,348139,100586,526058,307742,668103,960128,425891,758786,568624,232557,510335,879272,408282,668,204176,217911,709996,779613,940677,573797,238050,215727,436521,865251,527270,1026473,569578,990423,103843,349393,364120,3333,418217,975042,107782,841876,812387,437546,523009,536864,181106,1034140,333797,554550,788419,288108,659362,89078,565256,408503,988564,397667,181409,826720,761094,895262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]