SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109815 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109815 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276802,442586,839253,390811,423283,504795,842750,275088,590487,155745,781055,170172,521844,306014,48150,794007,651570,256616,821004,832059,329080,581852,853364,230211,330815,244377,236566,321526,668866,700239,928142,876905,190673,779969,248593,37131,839681,18939,594394,216401,133847,511660,907568,226721,727183,283796,339367,836812,760339,167287,382281,676543,1003683,602968,463436,259238,576205,734631,304809,812547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]