SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107618 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107618 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338364,161662,167794,617018,260747,378458,143373,402768,789620,352667,709843,866063,610556,834778,178122,100058,1038711,834458,581032,76088,708572,786373,345215,604272,877233,979390,232483,422544,713615,129443,102359,440066,77997,790140,925126,1015215,827838,1033113,1046290,217701,374921,305620,35418,870986,645990,764537,874374,567688,585024,100486,176911,446216,1036803,510834,520871,806372,443197,1030042,166904,848003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002586s ]