SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101900 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101900 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755036,309917,273342,700588,640519,603313,639425,988928,692624,1005222,373417,491248,797280,279275,88887,1044192,230674,101050,19960,413502,682446,488095,808602,440217,655811,932007,847879,249390,556337,182535,261487,492451,272029,65380,1038085,751973,236094,701781,569663,238901,676216,431073,52742,527288,725146,1013670,482979,759627,134316,986868,509294,968289,641262,289005,540523,786402,791670,947311,58763,590342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]